// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   register_ok.java

package intrmanufacture.file;

import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import java.io.IOException;
import java.io.PrintWriter;
import java.net.URL;
import java.sql.ResultSet;
import java.util.*;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;

public class register_ok extends HttpServlet
{

	private static final long serialVersionUID = 0xb21349a2a6f91420L;
	ServletContext application;
	HttpSession session;

	public register_ok()
	{
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			PrintWriter out = response.getWriter();
			nseer_db_backup1 design_db = new nseer_db_backup1(dbApplication);
			nseer_db_backup1 intrmanufacture_db = new nseer_db_backup1(dbApplication);
			if (design_db.conn((String)dbSession.getAttribute("unit_db_name")) && intrmanufacture_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				String kind_chain = request.getParameter("kind_chain");
				String chain_id = Divide1.getId(kind_chain);
				String chain_name = Divide1.getName(kind_chain);
				String provider_ID = NseerId.getId(getClass().getResource("").toString(), (String)dbSession.getAttribute("unit_db_name"));
				String intrmanufacturer = request.getParameter("intrmanufacturer");
				String intrmanufacturer_ID = request.getParameter("intrmanufacturer_ID");
				String provider_name = request.getParameter("provider_name");
				String provider_address = request.getParameter("provider_address");
				String type = request.getParameter("type");
				String provider_class = request.getParameter("class1");
				String used_provider_name = request.getParameter("used_provider_name");
				String provider_bank = request.getParameter("provider_bank");
				String provider_account = request.getParameter("provider_account");
				String provider_web = request.getParameter("provider_web");
				String provider_tel1 = request.getParameter("provider_tel1");
				String provider_fax = request.getParameter("provider_fax");
				String provider_postcode = request.getParameter("provider_postcode");
				String contact_person1 = request.getParameter("contact_person1");
				String contact_person1_department = request.getParameter("contact_person1_department");
				String contact_person1_duty = request.getParameter("contact_person1_duty");
				String contact_person1_sex = request.getParameter("contact_person1_sex");
				String contact_person1_office_tel = request.getParameter("contact_person1_office_tel");
				String contact_person1_home_tel = request.getParameter("contact_person1_home_tel");
				String contact_person1_mobile = request.getParameter("contact_person1_mobile");
				String contact_person1_email = request.getParameter("contact_person1_email");
				String contact_person2 = request.getParameter("contact_person2");
				String contact_person2_department = request.getParameter("contact_person2_department");
				String contact_person2_duty = request.getParameter("contact_person2_duty");
				String contact_person2_sex = request.getParameter("contact_person2_sex");
				String contact_person2_office_tel = request.getParameter("contact_person2_office_tel");
				String contact_person2_home_tel = request.getParameter("contact_person2_home_tel");
				String contact_person2_mobile = request.getParameter("contact_person2_mobile");
				String contact_person2_email = request.getParameter("contact_person2_email");
				String register = request.getParameter("register");
				String register_time = request.getParameter("register_time");
				String bodyc = new String(request.getParameter("invoice_info").getBytes("UTF-8"), "UTF-8");
				String invoice_info = exchange.toHtml(bodyc);
				String bodya = new String(request.getParameter("demand_products").getBytes("UTF-8"), "UTF-8");
				String demand_products = exchange.toHtml(bodya);
				try
				{
					String sqll = (new StringBuilder("select * from intrmanufacture_file where provider_ID='")).append(provider_ID).append("' and provider_name='").append(provider_name).append("'").toString();
					ResultSet rset = intrmanufacture_db.executeQuery(sqll);
					if (rset.next())
					{
						response.sendRedirect("intrmanufacture/file/register_ok_a.jsp");
					} else
					{
						String sql = (new StringBuilder("insert into intrmanufacture_file(chain_id,chain_name,provider_ID,provider_name,provider_address,provider_class,type,provider_bank,provider_account,provider_web,provider_tel1,provider_fax,provider_postcode,used_provider_name,contact_person1,contact_person1_department,contact_person1_duty,contact_person1_sex,contact_person1_office_tel,contact_person1_home_tel,contact_person1_mobile,contact_person1_email,contact_person2,contact_person2_department,contact_person2_duty,contact_person2_sex,contact_person2_office_tel,contact_person2_home_tel,contact_person2_mobile,contact_person2_email,register,register_time,invoice_info,demand_products,check_tag,modify_tag,excel_tag,intrmanufacturer,intrmanufacturer_ID) values ('")).append(chain_id).append("','").append(chain_name).append("','").append(provider_ID).append("','").append(provider_name).append("','").append(provider_address).append("','").append(provider_class).append("','").append(type).append("','").append(provider_bank).append("','").append(provider_account).append("','").append(provider_web).append("','").append(provider_tel1).append("','").append(provider_fax).append("','").append(provider_postcode).append("','").append(used_provider_name).append("','").append(contact_person1).append("','").append(contact_person1_department).append("','").append(contact_person1_duty).append("','").append(contact_person1_sex).append("','").append(contact_person1_office_tel).append("','").append(contact_person1_home_tel).append("','").append(contact_person1_mobile).append("','").append(contact_person1_email).append("','").append(contact_person2).append("','").append(contact_person2_department).append("','").append(contact_person2_duty).append("','").append(contact_person2_sex).append("','").append(contact_person2_office_tel).append("','").append(contact_person2_home_tel).append("','").append(contact_person2_mobile).append("','").append(contact_person2_email).append("','").append(register).append("','").append(register_time).append("','").append(invoice_info).append("','").append(demand_products).append("','0','0','1','").append(intrmanufacturer).append("','").append(intrmanufacturer_ID).append("')").toString();
						intrmanufacture_db.executeUpdate(sql);
						CdefineUpdate CdefineUpdate = new CdefineUpdate();
						sql = CdefineUpdate.update("intrmanufacture_file", "provider_ID", provider_ID, request);
						intrmanufacture_db.executeUpdate(sql);
						List rsList = new ArrayList();
						String elem[] = new String[3];
						sql = "select id,describe1,describe2 from intrmanufacture_config_workflow where type_id='01'";
						for (rset = intrmanufacture_db.executeQuery(sql); rset.next(); rsList.add(elem))
						{
							elem = new String[3];
							elem[0] = rset.getString("id");
							elem[1] = rset.getString("describe1");
							elem[2] = rset.getString("describe2");
						}

						if (rsList.size() == 0)
						{
							sql = (new StringBuilder("update intrmanufacture_file set check_tag='1' where provider_ID='")).append(provider_ID).append("'").toString();
							intrmanufacture_db.executeUpdate(sql);
						} else
						{
							for (Iterator ite = rsList.iterator(); ite.hasNext(); intrmanufacture_db.executeUpdate(sql))
							{
								elem = (String[])ite.next();
								sql = (new StringBuilder("insert into intrmanufacture_workflow(config_id,object_ID,describe1,describe2) values ('")).append(elem[0]).append("','").append(provider_ID).append("','").append(elem[1]).append("','").append(elem[2]).append("')").toString();
							}

						}
						response.sendRedirect((new StringBuilder("intrmanufacture/file/register_choose_attachment.jsp?provider_ID=")).append(provider_ID).toString());
					}
				}
				catch (Exception ex)
				{
					out.println((new StringBuilder("error")).append(ex).toString());
				}
				intrmanufacture_db.commit();
				design_db.commit();
				intrmanufacture_db.close();
				design_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
